Best Of
Re: March Question of the Month - Join the conversation and receive a badge
A skill that could use improvement for me is cooking- I am slowly learning more but there are still lots of things to learn to be more confident in the kitchen!
Janae G.
Re: March Question of the Month - Join the conversation and receive a badge
Some skills that I would like to improve on is my time management and organization. I participate in many events outside of my day job, so being able to balance all of this will help me with maximizing my productivity.
Thumphrey
Create a select all option in blueprint summary
The thing is, when you have to select like 100+ instead of only 1 checkbox… its a waste of time
Rafael L
Re: Default Drop Down Value
This is actually a daily pain that needs a solution. Very simply, allow a default value to be used for any columns with column Type of have a dropdown (multi or single select), checkbox or symbol.
I know forms can be setup - this is a separate request as I am not using forms in this case. I have also worked hard to get automations setup to do this, only to be told that they would not work.
This should be a very simple request. Please up vote it!
Sheet history with deleted rows
When we synchronize a Smartsheet sheet with another application and delete a row, sometimes the row cannot be deleted in the other application due to business rules, and we must restore the row’s data.
Additionally, sometimes when a row is deleted, we need to send specific data from a cell, but we no longer have access to this information.
It would be helpful to have a sheet history or a row bin to restore or access deleted row data.
Rubén Álvarez
Re: Power Automate to save a Smartsheet attachment to SharePoint
Create templates WITHIN an existing workspace
Hi,
We need the ability to create and use a template set within an existing workspace, without it creating a separate workspace.
Steps: Create> browse templates> create from template but IN an already existing workspace without creating a workspace labelled with the template name.
Csellers
Re: Form has a contact list field, for the contacts are not pulling into the form
I have the same situation. Don't understand the proposed work around "...add the contacts manually to the selection list...." Is this saying we would change the column type from Contact List to a Drop Down and then add all contacts to the drop down (potentially more than 100 people)?
It seems that Smartsheet is capable of using drop-down parameters in a form, but not contact lists.
Walter2112
Re: Form has a contact list field, for the contacts are not pulling into the form
If the form does not allow the user to select a contact from the list, but instead just saves the name, how does that impact my approval workflow when I am using the contact name from that field in my workflow automation?
Robin0618
Re: I am looking to autotrack attendees of training sessions in MS Teams into SmartSheet
Yes, Power Automate is an excellent solution for automatically tracking attendees from a Teams meeting into Smartsheet. Since the attendance report cannot be automatically uploaded to OneDrive or SharePoint, a workaround is to manually upload it to a designated folder, which then triggers a Power Automate flow.
Steps to Automate Attendance Tracking:
- Set Up a Power Automate Flow
- Use the "When a file is created in a folder" trigger (for OneDrive or SharePoint).
- Ensure that this folder is where you upload the attendance reports manually.
- Extract Attendance Data
- Since the CSV report* does not have a structured table format, use Text and Array expressions in Power Automate to split and filter relevant sections:
- Summary (Meeting Title, Start Time, Duration, etc.)
- Participants (Name, Email, Join Time, Leave Time, Role)
- Since the CSV report* does not have a structured table format, use Text and Array expressions in Power Automate to split and filter relevant sections:
- Insert Data into Smartsheet
- As @Isaac A. commented, Power Automate does have a Smartsheet connector, so once you get the necessary information from the report, you can add rows.
- Use the "Add a row" action from the Smartsheet connector.
- Map extracted fields to appropriate columns in your Smartsheet.
(*)
Additional Notes:
- You don’t need to be an Office 365 Admin or a Smartsheet Admin. Being the meeting organizer or having access to the attendance report and the target Smartsheet is sufficient.
- The Smartsheet connector in Power Automate allows easy row additions but does not support complex data manipulations natively—hence, parsing the CSV correctly is the most challenging step
Details of setting up Power Automate are beyond the scope of this community. However, if you need further assistance, you can contact me via email at my profile page.
Hope this helps! 😁
